In this video we will learn how to manipulate or change the data that we already have in a cell.
And we will also understand the types of data that we have an exit
to this is where we left off in the last video.
We have this file saved named Excel basics.
We double click on it to open it.
We have some data in these cells B2 to C4 in this worksheet if you select cell B2 and start typing No.
It was clearly cell first and entered the new input.
You have given.
So if I start writing columns again you'll see that I have to type it again completely but what if I
just wanted to edit some part of the text without clearing the content.
For example I want to write number of columns instead of just columns.
How do you do that.
For that we double click on this cell not this cell is in edit mode.
You can click wherever you want to edit that is add or remove text.
You will see this blinking cursor there.
Now you can type the new text number of
and hit into your cell is updated no another way of editing content is to select cell and editing it
in the formula but so if I want to remove this number of part I can just select that and press backspace
or delete key.
Now if you want to clear the cell that is if you want to delete the content of the cell you can select
the cell and press backspace or the delete key of your keyboard.
You can see that the content of that cell is cleared.
Now you can enter a new text if you want to.
So here's a quick recap to replace text in a cell click that cell and type the new text
to edit a text double click on that cell and then type
to clear the text.
Click on that cell and press delete or Backspace.
This is all retained existing data insult OK.
Now we are going to discuss types of data we enter induces basically the data is only three types.
One is textual which consists of alphabets such as these will be two which contains the text columns
the second papers numeric which consists of numbers such as the cell C 2 which contains this numeric
value of sixteen thousand three hundred eighty four and the third diapers formula such as the cell C4
in which we have read and the formula is equal to see to include s.t. within numeric type of data.
There are more tapes of formats in the home that in the dropdown head you can see various other formats.
By default it will be a general if you select number.
It will become numeric with two decimal points
if you select guarantee it will add a currency symbol such as this dollar or rupee symbol and a comma
at appropriate positions.
There are various other formats also but one of the most important in format is the date format.
We need to understand a concept hit Excel Create Date and time as a special type of numeric value the
earliest date that Excel understand is January 1st Nineteen Hundred this date is taken as number one.
To illustrate let's enter one in this in
now let's say like long date format in the dropdown
you can see no one is converted into this date.
1st January nineteen hundred which is the first date for Excel if you enter number two that will be
converted to January to nineteen hundred.
And the cities goes on.
We do not need to concern ourselves with the numeric date format do if you entered 2nd June in this
hall and press into Excel understand that it is a date and handle it accordingly
we understood that concept that data to handle as a numeric value because sometimes when you open someone
else's excel file you may find that there are numbers in the date column.
Now you would know that you just need to select that number and DC format to be type.
Same goes with the time format.
Apart from that when you have textual data in a column say in the Big Island we have textual data.
Now if we start typing new text in this column Excel will auto recommend textual values.
This other values in that column.
So since the last value in this column is says if your Type C Excel will recommend that you can enter
cells.
If you accept this change you can press enter and the cell will have the value cells.
If you do not want to use that value you can just continue typing whatever you want to take.
And another thing about numerical values.
So when we converted that number which was in general format to a number format we saw that there were
two digits added after a decimal point.
If you want to remove these dithered or if you want to increase the number of digits after the decimal
point you can click.
These two options The first option increases the number of digits after the decimal point.
And the second option reduces the number of digits after the decimal point.
So if we have value of pi in this L as three point 1 4 1 5 9
and you think that these are too many digit for most of your calculations you just need to look at only
two decimal lettered.
You can go and click on this option to reduce the number of digits that are visible to
you can see in the form lower the original values retained.
But in this cell you will see only the number of letters which you specified with this.
We conclude the selected.